<?php

include('includes/session.inc');

$Title = _('Periods Inquiry');

include('includes/header.inc');

$SQL = "SELECT periodno ,
		lastdate_in_period
		FROM periods
		ORDER BY periodno";

$ErrMsg = _('No periods were returned by the SQL because');
$PeriodsResult = DB_query($SQL, $db, $ErrMsg);

echo '<p class="page_title_text noPrint" ><img src="' . $RootPath . '/css/' . $Theme . '/images/transactions.png" title="' . $Title . '" alt="" />' . ' ' . $Title . '</p>';

/*show a table of the orders returned by the SQL */

$NumberOfPeriods = DB_num_rows($PeriodsResult);
$PeriodsInTable = round($NumberOfPeriods / 3, 0);

echo '<table><tr>';

for ($i = 0; $i < 3; $i++) {
	echo '<td valign="top">';
	echo '<table cellpadding="2" class="selection">
			<tr>
				<th>' . _('Period Number') . '</th>
				<th>' . _('Date of Last Day') . '</th>
			</tr>';
	$k = 0;
	while ($myrow = DB_fetch_array($PeriodsResult)) {
		if ($k == 1) {
			echo '<tr class="EvenTableRows">';
			$k = 0;
		} else {
			echo '<tr class="OddTableRows">';
			$k++;
		}
		echo '<td>' . $myrow['periodno'] . '</td>
			  <td>' . ConvertSQLDate($myrow['lastdate_in_period']) . '</td>
			</tr>';
		$j++;
		if ($j == $PeriodsInTable) {
			break;
		}
	}
	echo '</table>';
	echo '</td>';
}

echo '</tr></table>';
//end of while loop

include('includes/footer.inc');
?>